SELECT Id FROM new_searchtable
where
(town = 'Cornish' and state='NH'
or town = 'Eastman' and state='NH'
or town = 'Enfield' and state='NH'
or town = 'Hanover' and state='NH'
or town = 'Lebanon' and state='NH'
or town = 'Lyme' and state='NH'
or town = 'Plainfield' and state='NH'
)
and (type = 'R' or type ='O')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 30
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:This 3 bedroom, 2 bath home may need some cosmetic updates but you will fall in love with the natural light and open floor plan! Light streams into the sunroom making it a cozy place to read a book or relax with your morning coffee. The living room features a big bay window to take in the Moose Mountain ridge line through the trees and has a a wonderful propane gas fireplace for those chilly nights. The kitchen/dining area is spacious with access to a deck and you will love the walk in pantry off the laundry room. The primary bedroom has an en suite bath and there is a second bedroom and full bath as well. Downstairs you have your third bedroom or office, a nice big storage room and a mudroom attached to the 2 car garage. Don't miss the big outbuilding which is perfect for all your toys and a workshop! The land is beautiful with it's own apple orchard (110 tress!) and a big garden plot. A wonderful spot walking distance to the Hanover Center Green in Etna where we have a summer fair and walking trails nearby. A wonderful community just 15 minutes to DHMC and Dartmouth College! Delayed showings start on Saturday, March 29 from 2-4.
Description:Nestled along the shores of Mascoma Lake and surrounded by the historic Shaker Museum you’ll find the community of North Village. A unique cluster of lovely homes, stylized with a hint of day’s gone by yet very modern on the interior. That’s exactly what you’ll find at 51 Chosen Vale Lane, built in 2002 and lovingly cared for this home has many features not found in the others. The large primary suite consists of vaulted ceilings, a separate dressing/sitting room with fireplace and spacious bath. The additional second floor suite again boasts a private bath, and a loft for those adventurous ones in the family. The main level is perfect for entertaining with an open concept living room, kitchen and dining room with built-ins and hardwood floors throughout. Red Birch & Mahogany cabinets, granite countertops and plenty of room for the best of cooks. The living room center piece is a fireplace mantel hand crafted by Dana Robes. A first-floor bedroom with a full bath rounds off the main level. A fully covered 3 season porch allows for lovely views of the lake, all within a short walk to the private Association beach. The lower level has a wonderful family room complete with bar, workshop, storage and laundry. The systems include two Air conditioning units one for each floor, a Buderus heating system, and a whole house sprinkler system. The Association maintains the roads, landscaping and beaches. Easy commute to Dartmouth College and the Dartmouth Medical Center.
Description:Lovely, Well-Maintained Three Bedroom Sitting in the Beautiful Connecticut River Valley Overlooking the Majestic Views of Mount Ascutney. This home sits on splendidly landscaped property encompassing 13+ acres of beautiful farmland with 1400 feet of private, accessible frontage on the Connecticut River. A wonderful spot to picnic, swim, canoe, kayak, fish, or just relax while taking in nature. A spacious open-concept kitchen, dining, and living room setting make it the perfect spot to entertain. The living room opens up to a large deck with stairs, adding more area for enjoyment. The conveniently designed kitchen features an island, numerous cherry cabinets, granite counters, and two pantries. Two bedrooms are on the first floor, one has a private 3/4 bath, the second shares a full bath. One of the many highlights of this home is magnificent Primary Suite privately situated on the upper level, offering a gas fireplace, 3/4 bath, and expansive Great Room complete with gas fireplace, wet bar, and half bath. Your own private oasis. The partially finished basement w/family area w/walk-out to the backyard. The garage is large enough to accommodate 4 vehicles with direct entry into a large, tiled mudroom. The glorious landscaping boasts gardens of mature flowering plants, blueberry bushes, asparagus, vegetable garden space, and a 20 x 20 pole barn. There is an easy commute to the Upper Valley. Situated in the coveted Town of Cornish, with a rich history of the Cornish Colony.
Description:A rare find! This Crystal Lake year round home sits on the lakeside with 120+ feet of shorefront. Enjoy the sunrises and gorgeous views. What more could you want with this adorable home? There's a full lake facing finished porch to relax on. All the conveniences with an updated kitchen, open living area, full bath and more. Wake up and look directly at the lake. It's not everyday you get a 2 car garage too on waterfront property. So much fun awaits and just in time for the summer. Join us at the Open House Saturday, April 26th 10 am to Noon
Description:Located just outside the heart of Hanover, the home is perfect for those looking for privacy. The home features a functional layout designed to take advantage of its natural surroundings. Hardwood floors run throughout the main level, where a spacious living room with a pellet stove offers a cozy retreat during colder months. The main level is bright and sunny with a wrap-around deck off the main living space which provides an ideal spot for enjoying the warmer months. The lower level provides great overflow space and includes a gas fireplace, a laundry area, and a three quarter bath. A converted garage spaces now serves as a practical mudroom, storage area, or potential workshop. Outside, the property’s expansive front and back yards, offer ample space for outdoor activities, gardening, privacy, and relaxation. With its desirable location near hiking trails, schools, and cultural attractions, this home offers a quiet retreat without sacrificing proximity to Hanover’s vibrant downtown.